Explore patron groups
-- Query database using SQL but save to R object
SELECT * FROM public.user_users;
-- Query database using SQL but save to R object
SELECT * FROM public.user_groups;
Count users per patron group
SELECT patron_group,
count(*) AS count
FROM public.user_users
GROUP BY patron_group
ORDER BY count DESC;
Show the patron group names
SELECT coalesce(g.group, 'unknown') AS user_group,
count(*) AS count
FROM public.user_users AS u
LEFT JOIN public.user_groups AS g ON u.patron_group = g.id
GROUP BY user_group
ORDER BY count DESC;